package com.yunkeji.api.index.mapper;

import com.yunkeji.api.index.vo.HelloContentVo;
import com.yunkeji.dao.mapper.SysHelloMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/** @author 老张 */
public interface ApiSysHelloMapper extends SysHelloMapper {

    @Select("SELECT id,content FROM ykj_sys_hello where sex=#{sex} ORDER BY RAND() LIMIT #{num};")
    List<HelloContentVo> randomOne(@Param("num") Integer num, @Param("sex") Integer sex);
}
